﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Vroom.Common
{
    public class Consts
    {
        #region ENV VARS
        
        public const string SQL_ENV_VAR = "SQL_ENV_VAR";
        public const string FILESOURCE_ENV_VAR = "FILESOURCE_ENV_VAR"; 

        #endregion


        #region SQL

        public const string SQL_ALIAS_CONF      = "CONF";
        public const string SQL_ALIAS_STAGING   = "STG";
        public const string SQL_ALIAS_DWH       = "DWH";
        public const string SQL_ALIAS_BUS       = "BUS";
        public const string SQL_ALIAS_REGPRO_ORACLE = "REGPRO_ORACLE";

        public const string SQL_ALIAS_CONF_KEY      = "SQL_ALIAS_CONF";
        public const string SQL_ALIAS_STAGING_KEY   = "SQL_ALIAS_STAGING";
        public const string SQL_ALIAS_DWH_KEY       = "SQL_ALIAS_DWH";
        public const string SQL_ALIAS_BUS_KEY       = "SQL_ALIAS_BUS";

        public const string SQL_SELECT_ALL = "SELECT * FROM ";
        public const string SQL_TRUNCATE = "TRUNCATE TABLE "; 

        #endregion


        #region CONN STRINGS

        public const string CONN_STR_CONF = "CONN_STR_CONF";
        public const string CONN_STR_STG  = "CONN_STR_STG";
        public const string CONN_STR_DWH  = "CONN_STR_DWH"; 

        #endregion


        #region FILE SOURCE LOC

        public const string SRC_FILE_LOC = "SRC_FILE_LOC"; 

        #endregion


        #region SSIS_CONF

        public const string ORACLE_DATASOURCE_SSIS_CONF_FILTER  = @"DataSource_RegProOracle";
        public const string ORACLE_DATASOURCE_SSIS_CONF_PATH    = @"\Package.Connections[RegProOracle].Properties[ConnectionString]";

        public const string STAGING_DATASOURCE_SSIS_CONF_FILTER = @"DataSource_Staging";
        public const string STAGING_DATASOURCE_SSIS_CONF_PATH   = @"\Package.Connections[Staging.Net].Properties[ConnectionString]"; 

        #endregion


        #region OTHER

        public const string ALL_STG_TBL     = "ALL_STG_TBL";
        public static string TWO_LINES      = Environment.NewLine + Environment.NewLine;
        public const string DWH_T_MINUS_1   = @"<DWH_T_MINUS_1>";

        #endregion


        #region REGEX

        public const string REGEX_SQL_HOST = "data source=(.*?)[;]"; 

        #endregion
    }
}
